SUPPORT / SAMPLES & SAS NOTES
Problem Note 52602: The value set for the "Maximum number of rows to display" option might be ignored when you open DBMS data in SAS® Enterprise Guide®
 |  |  |  |  |
SAS Enterprise Guide might ignore the value that you have specified for the option Maximum number of rows to display in the data grid with SAS/ACCESS data. This problem occurs when you open DBMS tables from the SAS Folders window. Specifically, instead of returning the number of rows that you have specified for this option, SAS Enterprise Guide returns all of the rows in the table. This behavior can severely impact performance.
Note: This option is set under Tools ► Options ► Data ► Performance.
Your setting for this option is correctly applied when you open DBMS tables from SAS libraries.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Enterprise Guide | Windows Vista for x64 | 4.3 | 9.2 TS2M3 | ||
| Windows Vista | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Ultimate 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Professional x64 | 4.3 | 6.1_M1 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Professional 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium x64 | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Home Premium 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Windows 7 Enterprise x64 | 4.3 | 6.1_M1 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Windows 7 Enterprise 32 bit | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows XP Professional | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2008 for x64 | 4.3 | 6.1_M1 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 R2 | 4.3 | 6.1_M1 | 9.2 TS2M3 | 9.4 TS1M0 | ||
| Microsoft Windows Server 2008 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Standard Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Enterprise Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 Datacenter Edition | 4.3 | 9.2 TS2M3 | ||||
| Microsoft Windows Server 2003 for x64 | 4.3 | 9.2 TS2M3 | ||||
| Microsoft® Windows® for x64 | 4.3 | 6.1_M1 | 9.2 TS2M3 | 9.4 TS1M0 | ||